速報APP / 教育 / Learn MS Excel : Video Tutorials

Learn MS Excel : Video Tutorials

價格:免費

更新日期:2019-04-16

檔案大小:3.5M

目前版本:1.0

版本需求:Android 4.1 以上版本

官方網站:http://www.sikapps.com

Email:contact@sikapps.com

聯絡地址:隱私權政策

Learn MS Excel : Video Tutorials(圖1)-速報App

Table of Contents:-

1) Excel Interface

2) Quick Access Toolbar

3) Workbooks and Worksheets

4) Formula Bar

5) Status Bar

6) Navigation Tools

7) Shortcut menus and Mini toolbar

8) Creating new workbooks

9) Tell Me Assistant and Help

10) Data Entry and Editing

11) Autofill

12) Dates and Times

13) Undo and Redo

14) Comments

15) Save and Save As

16) Basic Formula for Calculations

17) Basic Formula Function

18) Duplicating Formulas

Learn MS Excel : Video Tutorials(圖2)-速報App

19) Year to Date Calculation

20) Percentage formula

21) Relative, absolute and mixed reference

22) SUM and AVERAGE

23) Common functions

24) Font styles and effects

25) Row height and column width

26) Alignment and warp text

27) Borders

28) Numeric and special formatting

29) Numbers and dates

30) Conditional formatting

31) Tables

32) Slicer

33) Working with Shapes

34) Inserting and Working with Pictures

35) SmartArt

36) Editing Rows and Columns

37) Hiding and Unhiding Rows and Columns

Learn MS Excel : Video Tutorials(圖3)-速報App

38) Moving and Copying Data

39) Finding and Replacing data

40) Printing Area and Titles

41) Page Layout

42) Page Break

43) Page Setup and Printing Controls

44) Creating Charts

45) Chart Types

46) Chart Formatting

47) Axes and Titles

48) Chart Elements

49) In-cell charts

50) Freezing and unfreezing panels

51) Splitting screens

52) Collapsing and Expanding data

53) Multiple workbooks display

54) Renaming, inserting, coloring and deleting

55) Moving, copying and grouping sheets

56) Linking worksheets and workbooks

Learn MS Excel : Video Tutorials(圖4)-速報App

57) Maintaining and locating links

58) IF function

59) VLOOKUP function for approximate data

60) VLOOKUP function for exact data

61) COUNTIF function

62) Unlocking and protecting worksheets

63) Workbook protection

64) Setting passwords

65) Tracking changes

66) Sorting

67) Inserting subtotals

68) Using filters

69) Splitting data

70) Flash Fill

71) Removing duplicate data

72) Validation tools

73) Goak Seek

74) Solver

75) Scenario Manager

Learn MS Excel : Video Tutorials(圖5)-速報App

76) Data Tables

77) Validation for Just Number or Text Input

78) Kutools for Validation

79) Pivot Tables Creation

80) Pivot Tables Manipulation

81) Grouping and date and time

82) Grouping by various facotors

83) Slicers

84) PivotCharts

85) Go to Special

86) Creating Macro

87) Running Macro and Assigning Buttons

88) Making a Grade Sheet

89) Generating Automatic Comments using Numbers

90) Autohide Tabs

91) Copying just the Visible Data Excluding

92) KuTools for Excel

93) Multiple User Sharing

94) Importing Paint 3D Models in MS Excel

Learn MS Excel : Video Tutorials(圖6)-速報App

-------------------------------------------------------

Disclaimer : Developer claims no credit for any video embedded in this app unless otherwise noted. Videos embedded in this app are copyright to its respectful owners. If there is an video appearing in this app that belongs to you and you do not want it to appear in this app, please contact us via email and it will be promptly removed.

Learn MS Excel : Video Tutorials(圖7)-速報App